using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DALServicePrice
/// </summary>
public class DALServicePrice
{
    public static int UpdateServicePrice(int serviceID, string weightDescription, int distanceID, decimal price)
    {
        SqlCommand command = DAL.CreateCommand();
        command.CommandText = SQL.UpdateServicePrice;
        command.CommandType = CommandType.Text;
        command.Parameters.AddWithValue("@ServiceID", serviceID);
        command.Parameters.AddWithValue("@WeightDescription", weightDescription);
        command.Parameters.AddWithValue("@DistanceID", distanceID);
        command.Parameters.AddWithValue("@Price", price);
        return DAL.ExecuteNonQuery(command);
    }
}
